You could also consider BottomN, but that's an aggregation function and because it does remove the records not matching the "n", no idea how it will behave in a data flow, and you mayb…

You have an "annoying" data type for this… (a date, with a number it is a bit "lighter"). The LSQL rank function works only in that way, in descending order, and doesn't have…

Do you need RANK to start with 1 or you just need the order given by RANK? This depends on your planned usage of that column value…

You come from OBIEE, nothing changed in OAS on how the RPD/Semantic Model is handled. In OBIEE you had a single RPD at any point in time, it's the same with OAS. You can create multiple semantic…

Hi @Julianne , Did you try using the forecast function as in expression? https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/functions.html I just added a table visualization in a workbook, a…